﻿IF OBJECT_ID ('dbo.CHO_HOLIDAY_CALENDAR') IS NOT NULL
	DROP TABLE dbo.CHO_HOLIDAY_CALENDAR
GO

IF OBJECT_ID ('dbo.CHO_HOLIDAY_CALENDAR_AUDIT') IS NOT NULL
	DROP TABLE dbo.CHO_HOLIDAY_CALENDAR_AUDIT
GO

IF OBJECT_ID ('dbo.CHO_HOLIDAY_CALENDAR_DATES') IS NOT NULL
	DROP TABLE dbo.CHO_HOLIDAY_CALENDAR_DATES
GO

IF OBJECT_ID ('dbo.CHO_HOLIDAY_CALENDAR_DATES_AUDIT') IS NOT NULL
	DROP TABLE dbo.CHO_HOLIDAY_CALENDAR_DATES_AUDIT
GO

IF OBJECT_ID ('dbo.CHO_SELECT_ALL_HOLIDAY_CALENDARS') IS NOT NULL
	DROP PROC dbo.CHO_SELECT_ALL_HOLIDAY_CALENDARS
GO

IF OBJECT_ID ('dbo.CHO_ADD_OR_UPDATE_TASK_HOLIDAY_CALENDAR') IS NOT NULL
	DROP PROC dbo.CHO_ADD_OR_UPDATE_TASK_HOLIDAY_CALENDAR
GO

IF OBJECT_ID ('dbo.CHO_DELETE_TASK_HOLIDAY_CALENDAR') IS NOT NULL
	DROP PROC dbo.CHO_DELETE_TASK_HOLIDAY_CALENDAR
GO

IF OBJECT_ID ('dbo.CHO_GET_ALL_HOLIDAY_CALENDAR_DATES_BY_ID') IS NOT NULL
	DROP PROC dbo.CHO_GET_ALL_HOLIDAY_CALENDAR_DATES_BY_ID
GO

IF OBJECT_ID ('dbo.CHO_GET_ALL_HOLIDAY_CALENDAR_DATES_BY_NAME') IS NOT NULL
	DROP PROC dbo.CHO_GET_ALL_HOLIDAY_CALENDAR_DATES_BY_NAME
GO

IF OBJECT_ID ('dbo.CHO_ADD_OR_UPDATE_TASK_HOLIDAY_CALENDAR_DATES') IS NOT NULL
	DROP PROC dbo.CHO_ADD_OR_UPDATE_TASK_HOLIDAY_CALENDAR_DATES
GO

IF OBJECT_ID ('dbo.CHO_DELETE_TASK_HOLIDAY_CALENDAR_DATE') IS NOT NULL
	DROP PROC dbo.CHO_DELETE_TASK_HOLIDAY_CALENDAR_DATE
GO

IF OBJECT_ID ('dbo.CHO_CLONE_HOLIDAY_CALENDAR') IS NOT NULL
	DROP PROC dbo.CHO_CLONE_HOLIDAY_CALENDAR
GO